select ColumnName, ColumnType, ColumnLength, Nullable, ColumnFormat, DecimalTotalDigits, DecimalFractionalDigits from DBC.Columns where TableName = '^0' and DataBaseName = '^1'; show view ^TABLE^; database ^DATABASE^;